import pymysql
db = pymysql.connect('localhost','root','root','test')
cursor = db.cursor()
cursor.execute('DROP TABLE IF EXISTS employee')
sql = """CREATE TABLE'employee'(
'id' int(10) NOT NULL AUTO_INCREMENT,
'fist_name'char(20)NOT NULL,
'last_name'char(20) DEFAULT NULL,
'age'int(11) DEFAULT NULL,
'sex'char(1) DEFAULT NULL,
'income'float DEFAULT NULL,
PRIMARY KEY('id')
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;"""
cursor.execute(sql)
print("Created table Successfull.")
db.close()